package com.tanhua.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tanhua.model.domain.Log;
import feign.Param;
import org.apache.ibatis.annotations.Select;

public interface LogMapper extends BaseMapper<Log> {

    //根据日期和类型统计总数
    @Select("select count(distinct user_id) from tb_log where log_time=#{logTime} and type=#{type}")
    Integer queryByLogTimeAndType(@Param("type") String type, @Param("logTime") String logTime);

    //根据日期统计总数
    @Select("select count(distinct user_id) from tb_log where log_time=#{logTime}")
    Integer queryLogTime(String logTime);

    //统计次日留存数量
    @Select("select count(distinct user_id) from tb_log where log_time=#{today} and user_id in (\n" +
            "\tselect user_id from tb_log where log_time=#{yesterday}  and type='0102' )")
    Integer queryNumRetention1d(@Param("today") String today, @Param("yesterday") String yesterday);
}
